package com.csoracle.dao;

import com.csoracle.beans.CheckItem;
import com.csoracle.beans.QueryPageVo;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface CheckItemMappper {

    public List<CheckItem> findList(QueryPageVo vo);

    @Insert("insert into t_checkitem values(null,#{code},#{name},#{sex},#{age},#{price},#{type},#{attention},#{remark})")
    Integer add(CheckItem checkItem);

    @Update("update t_checkitem set code =#{code},name=#{name},sex=#{sex}," +
            "age=#{age},price=#{price},type=#{type},attention=#{attention},remark=#{remark}" +
            "where id=#{id}")
    Integer update(CheckItem checkItem);
}
